package com.isoft.systemprovidor.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.isoft.systemprovidor.entity.ExternalManage;
import com.isoft.systemprovidor.entity.PhoneBook;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ExternalManageDao extends BaseMapper<ExternalManageDao> {
    /*获取外聘须知*/
    @Select("SELECT * FROM TMIM_SYSTEM.TB_EXTERNAL WHERE ID = 1;")
    public ExternalManage getExternalManage();

    /*修改外聘须知*/
    @Insert("UPDATE TMIM_SYSTEM.TB_EXTERNAL SET LASTMODIFIER = #{lastmodifier} ,LASTDATE = #{lastdate}, EXTCONTENT =#{extcontent}  WHERE ID = 1;")
    public int updataExternal (ExternalManage externalManage);
}
